2013-02-01 - 4495 - Specs - Hong Kong WM Data Conversion #WMProject
SPECIFICATIONS
4495 - Specs for Data Conversion Activities
Purpose
Data Conversion activities for Hong kong Warehouse
Admin Info
Purpose
|
Data Conversion Activities
|
Requested By
|
Rahul
|
Spec Created By
|
Vengal /Durga
|
Spec Created Date
|
03/18/2013
|
Spec QA by
|
Vengal
|
Objects
|
|
Document Status
|
Complete
|
References
Prior Tickets
Documents
Functional Requirement
Following activities are being performed as part of Data Conversion for Hong Kong Warehouse
1) Movement of Stock from PRVA to HKDC /KRDC
2) Extension of Warehouse views & New Storage Locations HKDC/ KRDC for existing materials for plant 0510 and 0580
3) Change of Storage locations in Open POs using MASS from PRVA to HKDC/ KRDC depending upon the Plants
4) Change of Storage location at Storage loc for EP in MRP 2 View of material master using MASS
5) Change the regular LSMW program used for Material creation to add new views ie WM views for plants 0510 /0580
6) Addition of Warehouse views for ROAL materials in plants 0510 and 0580 while creation.
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
1) The material conversion has 3 steps
a) Material transfer using MB1B from storage location PRVA to HKDC (IM LEVEL)
b) Material transfer from HKDC to Warehouse and this involves Transfer Order creation
c) Confirmation of Transfer Order
2) For these activities we are using LSMW program to extend WM views to plants 0510 and 0580 as well as Plant data/Storage locations views to HKDC and KRDC.
3) Change the Storage locations in POs which are open (delivery not completed) from PRVA to HKDC (if plant is 0510 ) AND KRDC (if plant is 0580).
4) Change EP Storage location at MRP2 for plants 0510 and 0580 to HKDC and KRDC respectively using MASS transaction
5) Change the regular LSMW program used for Material creation to add new WM views for plants 0510 / 0580.
6) Addition of Warehouse views for ROAL materials in plants 0510 and 0580 while creation.
Test Plan
[List test scenarios/cases to be executed here]
Solution Details
[Provide complete technical details for configuration or programming here]
1) The material conversion steps are as follow:
a) Material transfer using MB1B from storage location PRVA to HKDC (IM LEVEL)
In these step we are transferring data from PRVA to HKDC through movement type 311 using MB1B TCODE.
The input file has following information
Material No , Grid , Batch Number , Quantity , Storage type and Storage Bin.
We used Direct input method (LSMW) for updating MB1B. Based on flat file we are updating all Fields in MSEG & MKPF table.
We are storing storage type, Section & Bin Number in Text Field of Doc.Header Text (In MB1B Screen)
Project: ZWM_MB1B
Sub project: ZWM_MB1B
Object: ZWM_MB1B
b) Material transfer from HKDC to Warehouse and this involves Transfer Order creation
From MKPF Table We are getting Material document number Storage Type , Bin Number ,User name & System date and Fiscal Year .
After Fetching data from MKPF we will go to LTBK table for Transfer Requirement Number .
Based on TR Number we will go LT04 tcode .
Here we did Recording for LT04 Following are steps .
!) Input for LT04 is TR number from LTBk table and Warehouse Number (HKW).
!!) After Input of above data we will select Palliation tab.
!!) These is important step for placing all quantity in allocated Bins.
Storage Type
Storage section
Storage Bin
Project: ZWM_MB1B
Sub project: ZWM_MB1B
Object: ZWM_LT04
c) Confirmation of Transfer Order
This one is done using Warehouse Monitor LL01.
2) For these activities we are using LSMW program to extend WM views to plants 0510 and 0580 as well as Plant data/Storage locations views to HKDC and KRDC.
In these LSMW Program we are extending materials to WM views for 0510 and 0580 plants/Storage locations.
For these we did Recording for MM01 to extend 5 views,they are,
a) General Plant Data / Storage 1
b) General Plant Data / Storage 2
c) Warehouse Management 1
d) Warehouse Management 2
e) AFS Warehouse Management
We are getting Input file as Date Range OR Material Numbers.
So based on Input we are fetching data from MARA table and MARC table.
From MARC table we are deleting all Entries except 0510 and 0580 Plants.
Project ZWAREHOUSE1
Subproject MATERIAL
Object EXTENSION
3) Change the Storage locations in POs which are open (delivery not completed) from PRVA to HKDC (if plant is 0510 ) AND KRDC (if plant is 0580).
Steps:
a) Collect all POs which are Open from table EKPO for plants 0510 and 0580 seperately
b) Using MASS program - MEMASSPO change the storage location from existing one to HKDC / KRDC as per plant and save it so that changes are done
c) Check for the log generated during the step b.
d) Once again enter all the POs in the table EKPO for which storage location has been changed and see whether the changes have been updated.
4) Change EP Storage location at MRP2 for plants 0510 and 0580 to HKDC and KRDC respectively using MASS transaction
a)Go to T code MASS and give Object type as BUS1001 Execute and Mass Maintenance screen will be open there you need to select table name MARC and execute.
b) Click Multiple selection for material to change and execute and give plant and execute.
c) Click Select fields and select field - Storage Location EP which you wanted to change to HKDC / KRDC and execute the process in background.
d) At SM37 we can see a job with name MASS running , on successful completion of the job we can check the spool of the job and confirm that the storage location has been changed.
e) Go to table MARC and see for above materials the storage location has been changed as part of Audit process.
5) Changes made to regular LSMW for addition of new views of WM for plants 0510 and 0580.
Project : ZBLUPLOAD
Subproject: FERT
Object : EXTENSION
6) Addition of Warehouse views for ROAL materials in plants 0510 and 0580 while creation.
a) Find the reference material from reference group which is used in the FGEN file
b) Extend the WM views for reference and configurable materials
In the Warehouse view 1 update following fields with data as follow
Stock Removal - 001
Stock Placement - 001
Storage Location Indicator - 001
c) Run the FGEN program ( T code - ZPP_FGEN ).
d) Go to table MLGN and check if the views has been updated for above materials.
Issues